![]() 12/28/2013 at 16:50 • Filed to: None | ![]() | ![]() |
Posting again for more input.
Charts! Charts! Charts! Charts!
If anyone would like to be an admin, let me know, you'll need a google login so I can share access to all the relevant files.
![]() 12/28/2013 at 16:51 |
|
Awesome!
![]() 12/28/2013 at 16:53 |
|
Bring back celebrity crush. I know we all just say Jennifer Lawrence, but that actually makes it just a little bit funnier.
![]() 12/28/2013 at 16:55 |
|
Ok, but it's going to be a drop down list with two entries. Jennifer Lawrence and other.
![]() 12/28/2013 at 16:56 |
|
Ugly as shit. At least leave the viewer the possiblity of sorting the data A -> Z. Like it is now, it's unnerving.
![]() 12/28/2013 at 16:56 |
|
Don't even bother with the "other" part
![]() 12/28/2013 at 16:59 |
|
Those charts are off the chart! Rad!
![]() 12/28/2013 at 17:03 |
|
To grant sort access would grant full editing access to the sheet. Something that was an issue with the original since people were accidentally deleting lines.
![]() 12/28/2013 at 17:07 |
|
Wouldn't fuel type (diesel?) and displacement be somewhat useful as well?
![]() 12/28/2013 at 17:07 |
|
Added it back in.
![]() 12/28/2013 at 17:09 |
|
MEW!
![]() 12/28/2013 at 17:16 |
|
There are scripts for auto sorting on open, I'll have a play with them to sort by username.
![]() 12/28/2013 at 17:17 |
|
Yours was better!
Now get off my lawn! I want to mourn the olden times in peace.
![]() 12/28/2013 at 18:10 |
|
just click view -> list
then you can sort them by whatever you like
![]() 12/28/2013 at 18:19 |
|
Thank you, in that way it works much better!
![]() 12/28/2013 at 18:40 |
|
I'll update the link on the form page to default to list view.
![]() 12/28/2013 at 18:53 |
|
The chart looks really nice...but I can't really see the colors with the key. Im red/green color blind and wish there was less multiple shades of green and red used. :(
![]() 12/28/2013 at 19:07 |
|
I'll tweak it so there isn't much red/green across the charts.
![]() 12/28/2013 at 19:14 |
|
Awesome, thanks.
![]() 12/28/2013 at 20:15 |
|
Woo! I just doubled the size of the 1940-49 bracket and tripled the Australia/Oceania population!
Old Tractors totally count as rides right?
![]() 12/28/2013 at 21:49 |
|
It's not going to go away...but after too many user fuck ups I was tired of constantly fixing it.
![]() 12/28/2013 at 22:00 |
|
So, are all the entries from the old spreadsheet thrown out? Do I need to input all 90 of my cars again?
![]() 12/28/2013 at 22:16 |
|
90? The official sheet has you with 12.
I'll import it into the new sheet once you've done that.
What I'll end up doing before the next 'best of oppo' post is updating the old sheet with the missing columns, everyone can punch them in, then I'll merge the two sheets together.
![]() 12/28/2013 at 22:51 |
|
I love how here, manuals make up 60% of all cars listed, but in reality while driving I know I'm almost always the only stick shift in a given area.
![]() 12/28/2013 at 23:00 |
|
Jalopnik - representative of the majority of drivers in the world, it is not. :)
![]() 12/28/2013 at 23:01 |
|
12 is roughly 90. I'm actually down to 11 now, got rid of an e39.
Can't edit that sheet. It's all good. I think most of em only have one engine option and one trans option.
![]() 12/28/2013 at 23:07 |
|
try now, I didn't have the edit option set, blow away whatever you don't want.
I've got the old list updated with the new columns and a flag if people want it imported into the new sheet, I'll post it up soonish.
![]() 12/28/2013 at 23:30 |
|
Got em
![]() 12/29/2013 at 00:07 |
|
Updated. The VW bus was a flat 4 if I'm not mistaken?
![]() 12/29/2013 at 00:25 |
|
dayum, I made 2 blank lines, and i need to edit my post since i own more than one boring car lol. Can you delete them and I can try again tomorrow?
![]() 12/29/2013 at 00:39 |
|
Done.
![]() 12/29/2013 at 00:49 |
|
thanx buddy, I'll start over tomorrow when i'm not in zombie mode lol. I just post all my current vehicles separately right? I'll pick the first to include the previous crap lol :]
![]() 12/29/2013 at 00:52 |
|
Yep, I've left the A6 entry in there, let me know if you want it cleared too.
![]() 12/29/2013 at 00:58 |
|
oh ok coool, thanks buddy :] you rule \m/
![]() 12/29/2013 at 03:05 |
|
The chart for years only seems to include up to 2009... help, help, I'm being repressed!
- '10 Lulzcer owner
![]() 12/29/2013 at 03:14 |
|
Fixed.
![]() 12/29/2013 at 14:06 |
|
Yeah it is. Makin about 20 hp after 30 years of tough duty in Alaska.
![]() 12/29/2013 at 20:59 |
|
Automatch, do you have a way I can contact you other then hunting through comments looking for your name?
I've got some stuff to add to an upcoming Best of Oppo about the readers rides, and a plan for how the original list can be updated and imported into the new list.
![]() 12/29/2013 at 21:35 |
|
AutomatchConsulting@gmail.com is the best way or you can find me on Twitter @AutomatchTom
![]() 12/30/2013 at 09:43 |
|
Thanks for putting this together. Added my rides, and definitely in a couple minority groups. One engine is a flat 4, another is twin turbo.
![]() 12/31/2013 at 19:29 |
|
Just found an error in the year counting formula. It doesn't count correctly
Right now you have the countif >=1960-countif >=1969
which means you're subtracting cars from 1969. Instead you need to do >=1970
![]() 12/31/2013 at 20:45 |
|
Fixed. Thanks for pointing that out.
![]() 01/01/2014 at 23:35 |
|
It's kind of a problem when you're on a laptop and the screen is really short. Some people's former cars , when listed, take up more space than the height of my entire screen, so their section occupies my entire screen at once.
![]() 01/01/2014 at 23:40 |
|
Noted, I'll have a play around with setting a maximum cell height.